PM Address MSTR (PM00300)

SELECT
       ['PM Address MSTR'].VENDORID AS 'PM Address MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM Address MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID

SELECT
       ['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
       ,['Address Electronic Funds Transfer Master'].ADRSCODE AS 'Address Electronic Funds Transfer Master-Address Code'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       SY06000 AS ['Address Electronic Funds Transfer Master']
              ON
                     ['PM Address MSTR'].ADRSCODE = ['Address Electronic Funds Transfer Master'].ADRSCODE
              AND
                     ['PM Address MSTR'].VENDORID = ['Address Electronic Funds Transfer Master'].VENDORID
              AND
                     ['Address Electronic Funds Transfer Master'].SERIES = 4

SELECT
       ['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
       ,['Internet Addresses'].ADRSCODE AS 'Internet Addresses-Address Code'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       SY01200 AS ['Internet Addresses']
              ON
                     ['PM Address MSTR'].ADRSCODE = ['Internet Addresses'].ADRSCODE
              AND
                     ['PM Address MSTR'].VENDORID = ['Internet Addresses'].Master_ID
              AND
                     ['Internet Addresses'].Master_Type = 'VEN'

SELECT
       ['PM Address MSTR'].SHIPMTHD AS 'PM Address MSTR-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PM Address MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD

SELECT
       ['PM Address MSTR'].TAXSCHID AS 'PM Address MSTR-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Address MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID

SELECT
       ['PM Address MSTR'].CCode AS 'PM Address MSTR-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       PM00300 AS ['PM Address MSTR']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['PM Address MSTR'].CCode = ['VAT Country Code MSTR'].CCode